Create Drill through Page Part2 15
Create Table Slicer
·
Select Slicer Visualization
·
Drag and Drop GroupName(groups) from ADF_Groups
Format
·
General
-
X-Position 16
-
Y-Position 272
-
Width 576
-
Height 64
·
Off Slicer header
·
Items
- Font Color #F1C40F
-
Background #34495E
-Text 10
·
Title
-
Title Text ----
Group Name (Grouped)
-
Font
Color #F1C40F
-
Background
Color #34495E
-
Alignment Center
-
Text 10
-
Font Family
Segoe UI Bold
· Background #34495E
Create Matrix Table
· Select
Matrix Visual
· Drag
and drop -CreatedDt from ADF_GroupQuestions
- GroupName(groups) ADF_Group
- GroupName, ADF_Group
- GroupQuestionText ADF_GroupQuestions
- Url ADF_GroupQuestions
· Values No. of Not Responded Qns
Format
General
-
X-Position 16
-
Y-Position 336
-
Width 576
-
Height 320
Grid
-
Outline color #F1C40F
-
Text Size 11
Column headers
-
Font Color Black
-
Font family Segoe UI Bold
-
Text Size 12
-
Alignment Center
Row
-
Font Color Black
-
Outline Right Only
-
URL Icon ON
Field Formatting
-
No. of Not Responded Qns
Conditional Formatting
-
No. of Not Responded Qns
Title Off
Background White
Shadow ON
Create Questions & Not
Responded % (Last 12) Visualization
·
Select Line and Clustered Column Chart
·
For the Shared Axis For the Week Hierarchy, For the Week,
DayofWeek
·
For Column values Field Drag and Drop Total Answer
Needed Qns
· For Line values Field Drag and Drop % of Not Responded Qns
·
Go to The Filters click on For the Week
-
Select Top N
-
Show Items Top 12
-
Drag and drop on by value Weekend from the date table
Formatting
·
General
-
X- position 608
-
Y- position 272
-
Width 656
-
Hight 384
·
Legend
-
Color Black
-
Font Family Segoe (Bold)
-
Text Size 10
·
X-Axis
-
Color-------------- Black
-
Text Size ----------9
-
Font family -------Segoe UI Bold
-
Title Color --------Black
-
Title Size---------- 12
·
Y-Axis
-
Color --------#F1C40F
-
Text ----------10
-
Line Style ------Dotted
-
Show Secondary ---On
-
Align Zeros --------On
-
Scaler type -------- Liner
-
Color --------------#34495E
-
Text ----------------16
·
Data Color
-
% of Not Responded Qns -----#34495E
- Default Color ------#F1C40F
·
Data Lab
-
Customize Series
ON
Total Answer Needed Qns
-
Show On
-
Color--------#F1C40F
-
Show background Color----Black
· Shapes
-
Shade area ON
-
Stroke width 3
-
Join type Round
-
Line style Dashed
-
Show marker ON
-
Marker shape Square
-
Marker size 5
- Marker Color White
-
Stepped ON
· Title
-
Title text FX
- Font Color #F1c40F
-
Background Color ------#34495E
-
Alignment------------Center
-
Font Family ----------Segoe UI Bold
· Background
-
Color White
· Shadow ON
-
Color Back
· Tooltip ON
How to setup drill through power bi desktop
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough